package com.example.springbootdemo.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;
import java.util.Map;

public interface DemoMapper {

    @Select("Select * from job")
    public List<Map<String,Object>> selectJobs();

    @Select("Select * from memberinfo where nickName=#{name}")
    public Map<String,Object> selectByName(String name);

    @Update("update memberinfo set pwd=#{pwd} where nickName=#{nickName}")
    public void updatePwd(
            @Param("nickName") String nickName,
            @Param("pwd")String pwd);

}
